Prerequisites

The following section lists the prerequisites for working with Qlik Replicate and a Google Cloud SQL for PostgreSQL source.

Qlik Replicate Server for Windows:

PostgreSQL ODBC Driver psqlodbc_12_02_0000-x64 only must be installed on the Qlik Replicate machine.

Make sure that the psql.exe path (e.g. "C:\Program Files\PostgreSQL\1202\bin") is added to the system PATH.

Qlik Replicate Server for Linux: On the Qlik Replicate machine:

Install postgresql12. For example, postgresql12-12.1-2PGDG.rhel7.x86_64.rpm is the package required for Red Hat 7.
Install the ODBC driver for postgresql12.

For example, postgresql12-odbc-12.01.0000-1PGDG.rhel7.x86_64.rpm is the client required for Red Hat 7.
Copy the driver location to the site_arep_login.sh file:

echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/lib64:/usr/pgsql-12/lib" >> site_arep_login.sh

This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.
Makes sure that the /etc/odbcinst.ini file contains an entry for PostgreSQL, as in the following example:

[PostgreSQL]

Description = PostgreSQL ODBC driver

Driver = /usr/pgsql-12/lib/psqlodbc.so

Setup = /usr/pgsql-12/lib/psqlodbcw.so

Debug = 0

CommLog = 1

UsageCount = 2

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!